<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name></x:Name><x:WorksheetOptions><x:Selected/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]-->
    <style type="text/css">
        .td
        {
            width: 84px;
        }
        .gdtjContainer .tb tr
        {
            text-align: center;
            vertical-align: middle;
        }
        .gdtjContainer .tb th
        {
            border-left: 0.5pt solid #000;
            border-bottom: 0.5pt solid #000;
            text-align: center;
            font-weight: normal;
            font-size: 10pt;
            middle: ;;height:30px;}
        .gdtjContainer .header th
        {
            font-size: 12pt;
        }
        .gdtjContainer .tb tr th.noleftborder
        {
            border-left: none;
        }
        .gdtjContainer .tb tr th.rightborder
        {
            border-right: 0.5pt solid #000;
        }
    </style>
</head>
<body>
    <div class="gdtjContainer">
        <table class="tb" cellspacing="0" cellpadding="0" border="0" width="2184px">
            <colgroup>
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
                <col class="td" />
            </colgroup>
            <tr style="height: 40px">
                <th style="font-size: 20pt; font-family: 宋体; border: none;" colspan="21">
						工资清单
                </th>
            </tr>
            <tr class="header">
                <th colspan="3" rowspan="1">
                  	  员工信息
                </th> 
                <th colspan="3" rowspan="1">
                  	  基本工资
                </th>
                <th colspan="4" rowspan="1">
                  	  福利工资
                </th>                                           
                <th rowspan="2">
                  	  基础工资合计
                </th>
                <th colspan="6" rowspan="1">
                  	  业绩提成
                </th>                  
                <th rowspan="2">
                  	  保险及个税
                </th>
                <th rowspan="2">
                                                              合计
                </th>
                <th rowspan="2">
                                                              状态
                </th>               
                <th rowspan="2" class="rightborder">
                                                             备注
                </th>
            </tr>
            <tr style="height: 40px" class="header">
                <th>
                  	员工
                </th>
                <th>
                  	部门
                </th>
                <th>
                 	 职位
                </th> 
                <th>
                  	基本工资
                </th>
                <th>
                  	绩效工资
                </th>
                <th>
                  	保密工资
                </th>
                <th>
                  	交通补贴
                </th>
                <th>
                  	通讯补贴
                </th>
                <th>
                  	工龄工资
                </th>
                <th>
                  	全勤奖
                </th>
                <th>
                  	合同提成
                </th>
                <th>
                  	课时提成
                </th>
                <th>
                  	托管提成
                </th>
                <th>
                  	邀约提成
                </th>
                <th>
                  	个人提成
                </th>
                <th>
                	团队提成
                </th>                                                                               
            </tr>
            {% for qs in queryset %}
            <tr>
                <th>{{qs.employe__name}}</th>
                <th>{{qs.employe__department__name}}</th>
                <th>{{qs.employe__office__name}}</th>
                <th>{{qs.salarylevel__base_salary}}</th>
                <th>{%widthratio qs.salarylevel__performance_salary 1 qs.performance_no%}</th>
                <th>{{qs.salarylevel__secrecy_salary}}</th>
                <th>{{qs.salarylevel__traffic_subsidy}}</th>
                <th>{{qs.salarylevel__comm_subsidy}}</th>
                <th>{{qs.yearfee}}</th>
                <th>{{qs.monthfee}}</th>
                <th>{%widthratio qs.salarylevel__performance_salary 1 qs.performance_no|add:qs.salarylevel__base_salary|add:qs.salarylevel__secrecy_salary|add:qs.salarylevel__traffic_subsidy|add:qs.salarylevel__comm_subsidy|add:qs.yearfee|add:qs.monthfee %}</th>
                <th>{{qs.tc_fee}}</th>
                <th>{{qs.tc_fee}}</th>
                <th>{{qs.trusteeship_fee}}</th>
                <th>{{qs.call_fee}}</th>
                <th>{{qs.tc_fee|add:qs.tc_fee|add:qs.trusteeship_fee|add:qs.call_fee}}</th>
                <th>{{qs.tc_all_fee}}</th>
                <th>{{qs.insure_fee}}</th>
                <th>{%widthratio qs.salarylevel__performance_salary 1 qs.performance_no|add:qs.salarylevel__base_salary|add:qs.salarylevel__secrecy_salary|add:qs.salarylevel__traffic_subsidy|add:qs.salarylevel__comm_subsidy|add:qs.yearfee|add:qs.monthfee|add:qs.tc_fee|add:qs.course_fee|add:qs.trusteeship_fee|add:qs.call_fee|add:qs.tc_all_fee%}</th>
                <th>
                	{% if qs.state %}
                		有效
                	{% else %}
                		待审核
                	{% endif %}
                </th>
                <th>{{qs.remark}}</th>
            </tr>
            {% endfor %}
        </table>
    </div>
</body>
</html>